
INSERT INTO TSTB_INVENTORY_TRANSACTION(    ID,    REFERENCE_ID,    LEVEL1_NUMBER,    LEVEL2_NUMBER,    REFERENCE_SOURCE,    WAREHOUSE_CODE,    LOCATION_NUMBER,    BATCH_NUMBER,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE_TIME,    TRANSACTION_QUANTITY,    TRANSACTION_CODE,    TRANSFER_STATUS,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    TSSQ_INVENTORY_TRANSACTION_ID.nextval,    0 as REFERENCE_ID,    null as LEVEL1_NUMBER,    null as LEVEL2_NUMBER,    null as REFERENCE_SOURCE,    'UTC1' as WAREHOUSE_CODE,    null as LOCATION_NUMBER,    null as BATCH_NUMBER,    12345 as STOCK_ITEM_NUMBER,    to_date('20110905', 'YYYYMMDD')  as TRANSACTION_DATE_TIME,    -5 as TRANSACTION_QUANTITY,    'M' as TRANSACTION_CODE,    0 as TRANSFER_STATUS,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;